load data
infile 'gbr_access_0930.dat'
truncate
into table g_gbr_web_access
fields terminated by ' '
(
ip char,
tmp1 char,
tmp2 char,
time char,
gmt char,
method char,
uri char,
protocol char,
return char,
file_size integer external
)
